DROP TABLE IF EXISTS jms_dws.dws_center_arrival_nonstop_sum_dt;
CREATE EXTERNAL TABLE jms_dws.dws_center_arrival_nonstop_sum_dt
(
    arrival_date    DATE COMMENT '到件日期',
    agent_area_code STRING COMMENT '代理区编码',
    center_code     STRING COMMENT '转运中心编码',
    agent_area_name STRING COMMENT '代理区名称',
    center_name     STRING COMMENT '转运中心名称',
    upload_num      INT COMMENT '上传次数',
    arrival_total   INT COMMENT '件数'
)
    comment '卸车到件不停机汇总数据'
    partitioned by (dt string comment '时间分区')
    stored as parquet
    location '/dw/hive/jms_dws.db/external/dws_center_arrival_nonstop_sum_dt'
    tblproperties (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );
MSCK REPAIR TABLE jms_dws.dws_center_arrival_nonstop_sum_dt;